Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2599
Missing cells	3928
Missing cells (%)	12.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	243.8 KiB
Average record size in memory	96.0 B

Variable types

Categorical	3
Numeric	9

Alerts

`County FIPS Code` has a high cardinality: 2599 distinct values	High cardinality
`County Name` has a high cardinality: 1583 distinct values	High cardinality
`< 100% of FPL` is highly correlated with `≥ 100% to ≤ 150% of FPL` and 7 other fields	High correlation
`≥ 100% to ≤ 150% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 150% to ≤ 200% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 200% to ≤ 250% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 250% to ≤ 300% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 300% to ≤ 400% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 400% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`Unknown` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`Total Plan Selections` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`< 100% of FPL` is highly correlated with `≥ 100% to ≤ 150% of FPL` and 7 other fields	High correlation
`≥ 100% to ≤ 150% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 150% to ≤ 200% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 200% to ≤ 250% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 250% to ≤ 300% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 300% to ≤ 400% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 400% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`Unknown` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`Total Plan Selections` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`< 100% of FPL` is highly correlated with `≥ 100% to ≤ 150% of FPL` and 7 other fields	High correlation
`≥ 100% to ≤ 150% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 150% to ≤ 200% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 200% to ≤ 250% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 250% to ≤ 300% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 300% to ≤ 400% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 400% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`Unknown` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`Total Plan Selections` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`< 100% of FPL` is highly correlated with `≥ 100% to ≤ 150% of FPL` and 7 other fields	High correlation
`≥ 100% to ≤ 150% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 150% to ≤ 200% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 200% to ≤ 250% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 250% to ≤ 300% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 300% to ≤ 400% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`> 400% of FPL` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`Unknown` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`Total Plan Selections` is highly correlated with `< 100% of FPL` and 7 other fields	High correlation
`< 100% of FPL` has 1228 (47.2%) missing values	Missing
`≥ 100% to ≤ 150% of FPL` has 71 (2.7%) missing values	Missing
`> 150% to ≤ 200% of FPL` has 59 (2.3%) missing values	Missing
`> 200% to ≤ 250% of FPL` has 93 (3.6%) missing values	Missing
`> 250% to ≤ 300% of FPL` has 223 (8.6%) missing values	Missing
`> 300% to ≤ 400% of FPL` has 319 (12.3%) missing values	Missing
`> 400% of FPL` has 1283 (49.4%) missing values	Missing
`Unknown` has 650 (25.0%) missing values	Missing
`≥ 100% to ≤ 150% of FPL` is highly skewed (γ1 = 23.84829317)	Skewed
`County FIPS Code` is uniformly distributed	Uniform
`County FIPS Code` has unique values	Unique
`< 100% of FPL` has 134 (5.2%) zeros	Zeros
`> 400% of FPL` has 214 (8.2%) zeros	Zeros
`Unknown` has 49 (1.9%) zeros	Zeros

Reproduction

Analysis started	2022-04-06 01:15:18.812940
Analysis finished	2022-04-06 01:15:33.468325
Duration	14.66 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

County FIPS Code
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	2599
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	20.4 KiB

48303	1
31119	1
48507	1
40079	1
22019	1
Other values (2594)	2594

Length

Max length	5
Median length	5
Mean length	4.928434013
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2599 ?
Unique (%)	100.0%

Sample

1st row	2013
2nd row	2016
3rd row	2020
4th row	2050
5th row	2060

Common Values

Value	Count	Frequency (%)
48303	1	< 0.1%
31119	1	< 0.1%
48507	1	< 0.1%
40079	1	< 0.1%
22019	1	< 0.1%
47119	1	< 0.1%
48161	1	< 0.1%
31125	1	< 0.1%
31123	1	< 0.1%
56035	1	< 0.1%
Other values (2589)	2589	99.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
48303	1	< 0.1%
54027	1	< 0.1%
13321	1	< 0.1%
55089	1	< 0.1%
47029	1	< 0.1%
42025	1	< 0.1%
39097	1	< 0.1%
46093	1	< 0.1%
18067	1	< 0.1%
51171	1	< 0.1%
Other values (2589)	2589	99.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

State Name
Categorical

Distinct	38
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	20.4 KiB

TX	254
GA	159
VA	134
MO	115
KS	105
Other values (33)	1832

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	AK
2nd row	AK
3rd row	AK
4th row	AK
5th row	AK

Common Values

Value	Count	Frequency (%)
TX	254	9.8%
GA	159	6.1%
VA	134	5.2%
MO	115	4.4%
KS	105	4.0%
IL	102	3.9%
NC	100	3.8%
IA	99	3.8%
TN	95	3.7%
NE	93	3.6%
Other values (28)	1343	51.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tx	254	9.8%
ga	159	6.1%
va	134	5.2%
mo	115	4.4%
ks	105	4.0%
il	102	3.9%
nc	100	3.8%
ia	99	3.8%
tn	95	3.7%
ne	93	3.6%
Other values (28)	1343	51.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

County Name
Categorical

HIGH CARDINALITY

Distinct	1583
Distinct (%)	60.9%
Missing	0
Missing (%)	0.0%
Memory size	20.4 KiB

Washington County	22
Jackson County	20
Jefferson County	20
Franklin County	18
Lincoln County	18
Other values (1578)	2501

Length

Max length	33
Median length	14
Mean length	14.00230858
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1227 ?
Unique (%)	47.2%

Sample

1st row	Aleutians East Borough
2nd row	Aleutians West Census Area
3rd row	Anchorage Municipality
4th row	Bethel Census Area
5th row	Bristol Bay Borough

Common Values

Value	Count	Frequency (%)
Washington County	22	0.8%
Jackson County	20	0.8%
Jefferson County	20	0.8%
Franklin County	18	0.7%
Lincoln County	18	0.7%
Union County	16	0.6%
Clay County	16	0.6%
Madison County	16	0.6%
Marion County	16	0.6%
Monroe County	15	0.6%
Other values (1573)	2422	93.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
county	2464	45.8%
parish	64	1.2%
city	47	0.9%
st	23	0.4%
washington	23	0.4%
jefferson	23	0.4%
jackson	21	0.4%
franklin	20	0.4%
lincoln	19	0.4%
union	17	0.3%
Other values (1571)	2655	49.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

< 100% of FPL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	342
Distinct (%)	24.9%
Missing	1228
Missing (%)	47.2%
Infinite	0
Infinite (%)	0.0%
Mean	160.1167031

Minimum	0
Maximum	7886
Zeros	134
Zeros (%)	5.2%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	19
median	42
Q3	107.5
95-th percentile	699.5
Maximum	7886
Range	7886
Interquartile range (IQR)	88.5

Descriptive statistics

Standard deviation	460.4733484
Coefficient of variation (CV)	2.87586079
Kurtosis	94.67786369
Mean	160.1167031
Median Absolute Deviation (MAD)	28
Skewness	8.22466995
Sum	219520
Variance	212035.7046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	134	5.2%
21	28	1.1%
16	27	1.0%
17	26	1.0%
13	25	1.0%
15	25	1.0%
14	25	1.0%
11	25	1.0%
12	25	1.0%
19	24	0.9%
Other values (332)	1007	38.7%
(Missing)	1228	47.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	134	5.2%
11	25	1.0%
12	25	1.0%
13	25	1.0%
14	25	1.0%
15	25	1.0%
16	27	1.0%
17	26	1.0%
18	17	0.7%
19	24	0.9%

Value	Count	Frequency (%)
7886	1	< 0.1%
5236	1	< 0.1%
5137	1	< 0.1%
4431	1	< 0.1%
4222	1	< 0.1%
3194	1	< 0.1%
3139	1	< 0.1%
2958	1	< 0.1%
2803	1	< 0.1%
2792	1	< 0.1%

≥ 100% to ≤ 150% of FPL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct	1131
Distinct (%)	44.7%
Missing	71
Missing (%)	2.7%
Infinite	0
Infinite (%)	0.0%
Mean	1299.230222

Minimum	0
Maximum	259328
Zeros	2
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	0
5-th percentile	22
Q1	87.75
median	255.5
Q3	724.5
95-th percentile	4167.95
Maximum	259328
Range	259328
Interquartile range (IQR)	636.75

Descriptive statistics

Standard deviation	7043.917854
Coefficient of variation (CV)	5.421608686
Kurtosis	769.8256506
Mean	1299.230222
Median Absolute Deviation (MAD)	204.5
Skewness	23.84829317
Sum	3284454
Variance	49616778.73
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	15	0.6%
30	14	0.5%
34	14	0.5%
14	13	0.5%
18	13	0.5%
35	13	0.5%
28	13	0.5%
40	13	0.5%
17	12	0.5%
22	12	0.5%
Other values (1121)	2396	92.2%
(Missing)	71	2.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	0.1%
11	8	0.3%
12	9	0.3%
13	15	0.6%
14	13	0.5%
15	9	0.3%
16	10	0.4%
17	12	0.5%
18	13	0.5%
19	10	0.4%

Value	Count	Frequency (%)
259328	1	< 0.1%
124985	1	< 0.1%
94440	1	< 0.1%
66926	1	< 0.1%
59838	1	< 0.1%
54548	1	< 0.1%
44536	1	< 0.1%
39504	1	< 0.1%
38996	1	< 0.1%
37355	1	< 0.1%

> 150% to ≤ 200% of FPL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	990
Distinct (%)	39.0%
Missing	59
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	822.8456693

Minimum	0
Maximum	72468
Zeros	3
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	0
5-th percentile	27
Q1	87
median	201
Q3	521
95-th percentile	3206.65
Maximum	72468
Range	72468
Interquartile range (IQR)	434

Descriptive statistics

Standard deviation	3005.346184
Coefficient of variation (CV)	3.652381359
Kurtosis	224.097408
Mean	822.8456693
Median Absolute Deviation (MAD)	145
Skewness	12.82725677
Sum	2090028
Variance	9032105.684
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	20	0.8%
107	15	0.6%
74	14	0.5%
71	14	0.5%
14	13	0.5%
33	13	0.5%
48	13	0.5%
41	13	0.5%
84	12	0.5%
27	12	0.5%
Other values (980)	2401	92.4%
(Missing)	59	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3	0.1%
11	3	0.1%
12	4	0.2%
13	8	0.3%
14	13	0.5%
15	4	0.2%
16	10	0.4%
17	8	0.3%
18	9	0.3%
19	10	0.4%

Value	Count	Frequency (%)
72468	1	< 0.1%
49639	1	< 0.1%
49527	1	< 0.1%
45331	1	< 0.1%
42206	1	< 0.1%
28740	1	< 0.1%
28515	1	< 0.1%
21794	1	< 0.1%
21064	1	< 0.1%
20868	1	< 0.1%

> 200% to ≤ 250% of FPL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	818
Distinct (%)	32.6%
Missing	93
Missing (%)	3.6%
Infinite	0
Infinite (%)	0.0%
Mean	481.0794094

Minimum	0
Maximum	29140
Zeros	6
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	0
5-th percentile	19
Q1	53
median	121.5
Q3	325.75
95-th percentile	1903.5
Maximum	29140
Range	29140
Interquartile range (IQR)	272.75

Descriptive statistics

Standard deviation	1551.151442
Coefficient of variation (CV)	3.224314763
Kurtosis	146.2784572
Mean	481.0794094
Median Absolute Deviation (MAD)	85.5
Skewness	10.42576763
Sum	1205585
Variance	2406070.796
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33	24	0.9%
46	22	0.8%
34	22	0.8%
42	21	0.8%
70	20	0.8%
30	20	0.8%
36	19	0.7%
27	19	0.7%
57	18	0.7%
24	18	0.7%
Other values (808)	2303	88.6%
(Missing)	93	3.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6	0.2%
11	13	0.5%
12	18	0.7%
13	14	0.5%
14	11	0.4%
15	17	0.7%
16	11	0.4%
17	14	0.5%
18	14	0.5%
19	14	0.5%

Value	Count	Frequency (%)
29140	1	< 0.1%
26658	1	< 0.1%
26074	1	< 0.1%
21759	1	< 0.1%
20043	1	< 0.1%
16328	1	< 0.1%
15507	1	< 0.1%
13529	1	< 0.1%
10968	1	< 0.1%
10585	1	< 0.1%

> 250% to ≤ 300% of FPL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	639
Distinct (%)	26.9%
Missing	223
Missing (%)	8.6%
Infinite	0
Infinite (%)	0.0%
Mean	294.8813131

Minimum	0
Maximum	14731
Zeros	12
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	35
median	81
Q3	206.25
95-th percentile	1212.5
Maximum	14731
Range	14731
Interquartile range (IQR)	171.25

Descriptive statistics

Standard deviation	839.2077704
Coefficient of variation (CV)	2.845917096
Kurtosis	111.1421355
Mean	294.8813131
Median Absolute Deviation (MAD)	56
Skewness	8.90686743
Sum	700638
Variance	704269.6819
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24	33	1.3%
19	32	1.2%
26	29	1.1%
16	29	1.1%
14	29	1.1%
20	28	1.1%
23	28	1.1%
27	26	1.0%
32	26	1.0%
29	24	0.9%
Other values (629)	2092	80.5%
(Missing)	223	8.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	12	0.5%
11	18	0.7%
12	23	0.9%
13	19	0.7%
14	29	1.1%
15	24	0.9%
16	29	1.1%
17	20	0.8%
18	24	0.9%
19	32	1.2%

Value	Count	Frequency (%)
14731	1	< 0.1%
14360	1	< 0.1%
10810	1	< 0.1%
10529	1	< 0.1%
10090	1	< 0.1%
8537	1	< 0.1%
8318	1	< 0.1%
7044	1	< 0.1%
5610	1	< 0.1%
5575	1	< 0.1%

> 300% to ≤ 400% of FPL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	616
Distinct (%)	27.0%
Missing	319
Missing (%)	12.3%
Infinite	0
Infinite (%)	0.0%
Mean	274.3609649

Minimum	0
Maximum	14205
Zeros	13
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	0
5-th percentile	14
Q1	32
median	73
Q3	196.25
95-th percentile	1181.95
Maximum	14205
Range	14205
Interquartile range (IQR)	164.25

Descriptive statistics

Standard deviation	740.8567103
Coefficient of variation (CV)	2.700299259
Kurtosis	106.9444524
Mean	274.3609649
Median Absolute Deviation (MAD)	51
Skewness	8.443658417
Sum	625543
Variance	548868.6652
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	35	1.3%
14	35	1.3%
25	34	1.3%
29	32	1.2%
20	32	1.2%
21	31	1.2%
13	31	1.2%
12	30	1.2%
30	29	1.1%
19	29	1.1%
Other values (606)	1962	75.5%
(Missing)	319	12.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	13	0.5%
11	25	1.0%
12	30	1.2%
13	31	1.2%
14	35	1.3%
15	21	0.8%
16	21	0.8%
17	23	0.9%
18	35	1.3%
19	29	1.1%

Value	Count	Frequency (%)
14205	1	< 0.1%
11740	1	< 0.1%
8722	1	< 0.1%
7838	1	< 0.1%
7250	1	< 0.1%
6944	1	< 0.1%
6707	1	< 0.1%
5612	1	< 0.1%
5108	1	< 0.1%
4705	1	< 0.1%

> 400% of FPL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	306
Distinct (%)	23.3%
Missing	1283
Missing (%)	49.4%
Infinite	0
Infinite (%)	0.0%
Mean	120.9825228

Minimum	0
Maximum	6068
Zeros	214
Zeros (%)	8.2%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	14
median	29
Q3	84
95-th percentile	555.75
Maximum	6068
Range	6068
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	342.8880701
Coefficient of variation (CV)	2.834195073
Kurtosis	112.3570906
Mean	120.9825228
Median Absolute Deviation (MAD)	26
Skewness	8.786321047
Sum	159213
Variance	117572.2286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	214	8.2%
13	34	1.3%
15	33	1.3%
11	33	1.3%
12	31	1.2%
17	29	1.1%
16	29	1.1%
14	27	1.0%
18	26	1.0%
19	26	1.0%
Other values (296)	834	32.1%
(Missing)	1283	49.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	214	8.2%
11	33	1.3%
12	31	1.2%
13	34	1.3%
14	27	1.0%
15	33	1.3%
16	29	1.1%
17	29	1.1%
18	26	1.0%
19	26	1.0%

Value	Count	Frequency (%)
6068	1	< 0.1%
4611	1	< 0.1%
4115	1	< 0.1%
2716	1	< 0.1%
2333	1	< 0.1%
2257	1	< 0.1%
2253	1	< 0.1%
1946	1	< 0.1%
1820	1	< 0.1%
1597	1	< 0.1%

Unknown
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	523
Distinct (%)	26.8%
Missing	650
Missing (%)	25.0%
Infinite	0
Infinite (%)	0.0%
Mean	268.5464341

Minimum	0
Maximum	16503
Zeros	49
Zeros (%)	1.9%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	25
median	53
Q3	150
95-th percentile	1168.4
Maximum	16503
Range	16503
Interquartile range (IQR)	125

Descriptive statistics

Standard deviation	904.1691085
Coefficient of variation (CV)	3.366900445
Kurtosis	143.5895666
Mean	268.5464341
Median Absolute Deviation (MAD)	36
Skewness	10.16087114
Sum	523397
Variance	817521.7767
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	49	1.9%
11	37	1.4%
15	37	1.4%
14	36	1.4%
13	35	1.3%
18	34	1.3%
17	32	1.2%
12	32	1.2%
16	31	1.2%
26	30	1.2%
Other values (513)	1596	61.4%
(Missing)	650	25.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	49	1.9%
11	37	1.4%
12	32	1.2%
13	35	1.3%
14	36	1.4%
15	37	1.4%
16	31	1.2%
17	32	1.2%
18	34	1.3%
19	26	1.0%

Value	Count	Frequency (%)
16503	1	< 0.1%
15654	1	< 0.1%
14602	1	< 0.1%
9096	1	< 0.1%
8458	1	< 0.1%
7398	1	< 0.1%
7111	1	< 0.1%
6009	1	< 0.1%
5748	1	< 0.1%
5443	1	< 0.1%

Total Plan Selections
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1729
Distinct (%)	66.6%
Missing	2
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3403.268387

Minimum	12
Maximum	392442
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	20.4 KiB

Quantile statistics

Minimum	12
5-th percentile	86.8
Q1	324
median	790
Q3	2068
95-th percentile	12913.6
Maximum	392442
Range	392430
Interquartile range (IQR)	1744

Descriptive statistics

Standard deviation	13482.9973
Coefficient of variation (CV)	3.96177902
Kurtosis	342.4611756
Mean	3403.268387
Median Absolute Deviation (MAD)	586
Skewness	15.37310029
Sum	8838288
Variance	181791216.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
145	7	0.3%
100	7	0.3%
82	7	0.3%
126	6	0.2%
62	6	0.2%
204	6	0.2%
164	5	0.2%
122	5	0.2%
163	5	0.2%
203	5	0.2%
Other values (1719)	2538	97.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12	2	0.1%
13	2	0.1%
14	1	< 0.1%
15	3	0.1%
17	1	< 0.1%
19	1	< 0.1%
21	1	< 0.1%
22	1	< 0.1%
24	1	< 0.1%
26	2	0.1%

Value	Count	Frequency (%)
392442	1	< 0.1%
226789	1	< 0.1%
222210	1	< 0.1%
157223	1	< 0.1%
136968	1	< 0.1%
129539	1	< 0.1%
128502	1	< 0.1%
108585	1	< 0.1%
94838	1	< 0.1%
94093	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	County FIPS Code	State Name	County Name	< 100% of FPL	≥ 100% to ≤ 150% of FPL	> 150% to ≤ 200% of FPL	> 200% to ≤ 250% of FPL	> 250% to ≤ 300% of FPL	> 300% to ≤ 400% of FPL	> 400% of FPL	Unknown	Total Plan Selections
0	2013	AK	Aleutians East Borough	NaN	12.0	NaN	NaN	NaN	NaN	0.0	NaN	29.0
1	2016	AK	Aleutians West Census Area	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	34.0
2	2020	AK	Anchorage Municipality	382.0	2373.0	1901.0	1620.0	948.0	896.0	163.0	465.0	8748.0
3	2050	AK	Bethel Census Area	12.0	12.0	18.0	20.0	NaN	NaN	NaN	NaN	83.0
4	2060	AK	Bristol Bay Borough	0.0	NaN	NaN	11.0	NaN	NaN	NaN	0.0	29.0
5	2068	AK	Denali Borough	NaN	39.0	30.0	30.0	29.0	20.0	NaN	NaN	163.0
6	2070	AK	Dillingham Census Area	NaN	NaN	13.0	NaN	NaN	NaN	NaN	NaN	39.0
7	2090	AK	Fairbanks North Star Borough	61.0	617.0	494.0	367.0	229.0	242.0	39.0	65.0	2114.0
8	2100	AK	Haines Borough	NaN	76.0	50.0	60.0	27.0	34.0	NaN	NaN	266.0
9	2105	AK	Hoonah-Angoon Census Area	NaN	44.0	32.0	16.0	12.0	NaN	NaN	0.0	119.0

Last rows

	County FIPS Code	State Name	County Name	< 100% of FPL	≥ 100% to ≤ 150% of FPL	> 150% to ≤ 200% of FPL	> 200% to ≤ 250% of FPL	> 250% to ≤ 300% of FPL	> 300% to ≤ 400% of FPL	> 400% of FPL	Unknown	Total Plan Selections
2589	56029	WY	Park County	22.0	414.0	356.0	290.0	196.0	178.0	16.0	65.0	1537.0
2590	56031	WY	Platte County	NaN	64.0	74.0	52.0	35.0	51.0	NaN	13.0	295.0
2591	56033	WY	Sheridan County	25.0	282.0	240.0	204.0	171.0	186.0	13.0	55.0	1176.0
2592	56035	WY	Sublette County	NaN	104.0	93.0	105.0	54.0	101.0	NaN	14.0	481.0
2593	56037	WY	Sweetwater County	21.0	307.0	210.0	171.0	115.0	126.0	18.0	50.0	1018.0
2594	56039	WY	Teton County	26.0	529.0	583.0	522.0	403.0	522.0	37.0	100.0	2722.0
2595	56041	WY	Uinta County	NaN	165.0	130.0	86.0	59.0	51.0	NaN	22.0	538.0
2596	56043	WY	Washakie County	NaN	98.0	77.0	46.0	21.0	56.0	NaN	NaN	319.0
2597	56045	WY	Weston County	NaN	54.0	22.0	36.0	20.0	22.0	NaN	NaN	161.0
2598	XXXXX	XX	Unknown	28.0	173.0	132.0	62.0	42.0	24.0	17.0	25.0	503.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows